Model Table SOURCE

This model dimension represents account sources defined in basic data and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
ID
Source CodeRepresents the Source Code
Source DescRepresents the Source Description
Source FunctionRepresents the Source Function

USED BY MODEL(S)

Model Name
Cash Planning
Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SOURCEDIM_CASH_PLAN_SOURCE_TMDIM_CASH_PLAN_SOURCE_BIDIM_CASH_PLAN_SOURCEOn Line